package com.recruit.mapper;

import com.recruit.model.AdvertisingDO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author tzg157
* @description 针对表【advertising(首页轮播广告)】的数据库操作Mapper
* @createDate 2023-11-22 11:20:30
* @Entity com.recruit.model.Advertising
*/
public interface AdvertisingMapper extends BaseMapper<AdvertisingDO> {

    @Select("select * from advertising where state <> 0 order by priority desc,update_time desc limit #{advPicsCount}")
    List<AdvertisingDO> advPics(@Param("advPicsCount") Integer advPicsCount);

}




